UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Tu7Pp8bH/KXVc3uySKAAWC/7huLg47HS2xEBlZljq0k=' 
WHERE 
  key_id = '9a2d94c2ae30bf3fde1b75e68a700889e16b9e4a1547a83d0c944d6d79c3c582' 
  AND (
    token = 'Tu7Pp8bH/KXVc3uySKAAWC/7huLg47HS2xEBlZljq0k=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00018