UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7Hahkwmf3X3ioX4k4la3I/S7Bfg+146bD/otMTVXxwc=' 
WHERE 
  key_id = '6c70f9c9a21c1eac9cf90056868a68ddbb383574de4e98916b01c71deb9d7785' 
  AND (
    token = '7Hahkwmf3X3ioX4k4la3I/S7Bfg+146bD/otMTVXxwc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023