UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '13cGAM5yXZ+PHy+wKd2KWbfAiBKw2Af9yalorkt/Znc=' 
WHERE 
  key_id = '42efafb359b436928330afc224a8045ad675debd968e87dc18e6044abffef5ae' 
  AND (
    token = '13cGAM5yXZ+PHy+wKd2KWbfAiBKw2Af9yalorkt/Znc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033