UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cGyYrqWSBROq6KBcQ9WlWohPwFDW8sh8BpsVNyhVzjo='
WHERE
key_id = '65101464c90da2b813e64c6c3bd5fb65cbe81d9234206acf4d582a9a1b0dea0b'
AND (
token = 'cGyYrqWSBROq6KBcQ9WlWohPwFDW8sh8BpsVNyhVzjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)