UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AclI9jZmM2FAOQqIspBGbEKCXWxN9BFqJQajNFJg4gU='
WHERE
key_id = '3a4a306fc150c653a0ae86dc9c5421c0d0fcdbaab4a83fa35345342507972440'
AND (
token = 'AclI9jZmM2FAOQqIspBGbEKCXWxN9BFqJQajNFJg4gU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)