Scottish Olympic cycling legend Sir Chris Hoy has revealed he has "two to four years" to live after he was diagnosed with terminal prostate cancer.