UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6bKXprX/eyxFUAMwUz47tDvblk62dappTwQaqBNdbLk='
WHERE
key_id = '5ab7490c0dfd8f7baa278ac2b2ca3777dd578399297e84aff82f862bad2afa47'
AND (
token = '6bKXprX/eyxFUAMwUz47tDvblk62dappTwQaqBNdbLk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)