UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tGEIEl9Y2DI6Rez1U0GJ6AzGAb8VAosWnnC5Ai6f6OY=' 
WHERE 
  key_id = 'ad715e44c325db0be2333d576094969c90da628911dacfac06af5b1e05577568' 
  AND (
    token = 'tGEIEl9Y2DI6Rez1U0GJ6AzGAb8VAosWnnC5Ai6f6OY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036