UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z1YxZ9jX0oosEj37z0nsmmhxodlwCnu6k5i9cE4/Nu0='
WHERE
key_id = 'efaa7bb41e8025e7f9c9528ef08d103c593efb64b795e9927f526523ea1b419c'
AND (
token = 'Z1YxZ9jX0oosEj37z0nsmmhxodlwCnu6k5i9cE4/Nu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)