UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'VjF0LsvCex2LrzL7j8Ok9jWlbllf9HjTZkiNa/B/mJs=' 
WHERE 
  key_id = '7997625d71a797bf359f0d1744b717f1eeb00c5522951045a3e6e030303bfa9e' 
  AND (
    token = 'VjF0LsvCex2LrzL7j8Ok9jWlbllf9HjTZkiNa/B/mJs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028