UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XvYGyDUR/Ev7kPZRMbXW8XEJm60zKvRX7vCISqU77ZM='
WHERE
key_id = '53c12f3ebf40a64e869b1dac3e90fd9b69919ef6a75621b1f3c71e5710bea6a2'
AND (
token = 'XvYGyDUR/Ev7kPZRMbXW8XEJm60zKvRX7vCISqU77ZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)