UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8Dy6pNU/ViWdHm95ARItDmENcr31pk8D1Xo/oHcotos=' 
WHERE 
  key_id = '669fccf32a29941365e6fd238b2f78c72401fcc5c0d1994f99233dc76ac8fb52' 
  AND (
    token = '8Dy6pNU/ViWdHm95ARItDmENcr31pk8D1Xo/oHcotos=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035