UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f6FxxEmU9aD0A0FNBHF8VoTesvVIp+h6tJsmAS/HGPo='
WHERE
key_id = '050730704b5b83f19706c4a7af33398de3b963acbea2a47f6b2b08646c210c57'
AND (
token = 'f6FxxEmU9aD0A0FNBHF8VoTesvVIp+h6tJsmAS/HGPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)