[TOMT] Man who was inspiration for action movie murdered

I recall watching a movie a few years ago and afterward reading up on the trivia of the film. The hero was based on a real person who was a soldier/mercenary(?). After the film, he milked this fame and became a bodyguard but ended up down and out. Ultimately he was shot to death (maybe in Mexico?) and I seem to recall was mixed up in drug trafficking and maybe prostitution. Google isn't being helpful and I can't piece together any other details to clarify.