UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jr0tGvhv6GYIyKmWnODgJiM0aa9XRXEUcwdE/pvtI4Y='
WHERE
key_id = '115f09c1bb46df52e24d25314a99fde337a8fc832a1a535d4208b062deba758c'
AND (
token = 'jr0tGvhv6GYIyKmWnODgJiM0aa9XRXEUcwdE/pvtI4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)