UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UqSPZ9wIBoYLR7IYso6pkl6ak1pMN6E3T55N9sNQPAE='
WHERE
key_id = '30d4c68d0c02d956f743f2e971b98f309d5cad832cbb837db21d361cfdf35c20'
AND (
token = 'UqSPZ9wIBoYLR7IYso6pkl6ak1pMN6E3T55N9sNQPAE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)