Sir Chris Hoy said his health situation is a "best case scenario" as he issued an update on his terminal cancer diagnosis.