UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XQk2DTWZYCGIxL7wuB3LseRj9SQX6fmO2lj1hEoTYRw='
WHERE
key_id = '4a2df7665096b3b207091abe5e5d4734c462ea89793724c686666369e5d00f87'
AND (
token = 'XQk2DTWZYCGIxL7wuB3LseRj9SQX6fmO2lj1hEoTYRw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)