Song is "The Last Hero" by Alter Bridge.

It is very much edited to fit these opening credits, but you can hear the original song here:
   • Alter Bridge - The Last Hero  

And of course, the original opening credits for Casino Royale (nothing, including my edit, will EVER replace Chris Cornell's "You Know My Name"):
   • Casino Royale Opening original