The Threave Rovers player was told just four weeks ago his cancer had spread and he only had weeks to live