UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQjDREvWfBasdMA0JDL+thTFFkW0sBmPxPDRp9Eu/QQ='
WHERE
key_id = 'e311893395a25d0e3d7054b38280b924c5b147e6f2bb7402abe9ffa6529a27a5'
AND (
token = 'sQjDREvWfBasdMA0JDL+thTFFkW0sBmPxPDRp9Eu/QQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)