UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oMqGyJL1QFMtsrykOtFpR21IkZs+Yfw/ucUz9OqUvF0='
WHERE
key_id = '3301d557418d35517a81096aea2fc0ffa0beb78820033311bbe141efef4610c5'
AND (
token = 'oMqGyJL1QFMtsrykOtFpR21IkZs+Yfw/ucUz9OqUvF0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)