"When you get when you get to my age, which is near 100, you think, ‘How much time have I got left?’" said John when discussing his new song with Brandi Carlile