UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iWNqmUsMfkDBkssrEdlXBvMc4EDvJSayzoGCOgXFzO0=' 
WHERE 
  key_id = '8cc0101e6b0357429e31fafe1ca8ae10d4425bf8f54b79c64f1e7047f27cb86e' 
  AND (
    token = 'iWNqmUsMfkDBkssrEdlXBvMc4EDvJSayzoGCOgXFzO0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025