UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nD9WJt4MGif2ybiVMClBRlBXYbMbvm04MqY/UKsaCy0='
WHERE
key_id = 'ea9b691623b3ad21e47cba27d0d0808044db5ad0667338a40a41b16c90202bd3'
AND (
token = 'nD9WJt4MGif2ybiVMClBRlBXYbMbvm04MqY/UKsaCy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)