UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7daIjRasUM5LxW3j6m58p/Hh39zG2+AjpjSxNBn9UQ='
WHERE
key_id = '3c1d58d2fb4e18a2cf3f82f3bfb731a57f587f4d4df1a3615a68ba68a99e52ac'
AND (
token = 'r7daIjRasUM5LxW3j6m58p/Hh39zG2+AjpjSxNBn9UQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)