Getting the bolt hot will expand it in the threads and lock it tighter, but welding a nut to it and waiting until it is cold and heat the sprocket might work.

2019 M3W Sold and is now in Las Vegas enjoying the showgirls :-)