Any part can fail at any time. The water pump is no exception. Actually water pumps are one of the most common repairs on most cars. How long they last depends on things like maintenance and things like was it made on a Monday or Friday.
Monday people are hung over, Friday people are wanting to go home to get drunk.