Waterspout in St. Johns County prompts short tornado warning