I have water tanks under the van, and a jerry at the rear....that I drink out of, and in 3 1/2 yrs have never emptied any of them , just refill to full before going camping.
A can of Coke will probably do you more harm than water that has been sitting around for ages !!