Cyclist and broadcaster Sir Chris Hoy opened up on his cancer diagnosis earlier this year and the 48-year-old has provided a heartbreaking update in a new interview