UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '2Rj8/oIF5vcRVIdM1idjlBzaKFvtskubWice78uEN1o=' 
WHERE 
  key_id = 'aa71d40de9f73df430ad60e35b8373145642d497fa5eb1f1d5122fd24b115c10' 
  AND (
    token = '2Rj8/oIF5vcRVIdM1idjlBzaKFvtskubWice78uEN1o=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033