UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Rn0GjcX4ZPpMN711Dj4lO4wuxLkg70o+vv2E4O4iFtg=' 
WHERE 
  key_id = 'ebf347f9102dcf8e7984b3c1b51f2ce1bad9201fd6c78dc66c97ad9f4d3754ea' 
  AND (
    token = 'Rn0GjcX4ZPpMN711Dj4lO4wuxLkg70o+vv2E4O4iFtg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038