UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QXKA9D6IYbuygT83OIvIixZjyJ/JzOAtPHSmP5AlHoY=' 
WHERE 
  key_id = 'f175577ea92ec5fa28b3b35a27cb67b69bd9e89460f6a21b210442d23c4b5cdc' 
  AND (
    token = 'QXKA9D6IYbuygT83OIvIixZjyJ/JzOAtPHSmP5AlHoY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00042