I don't have any idea why you think "a wife, kids" are out of the picture for you: after early adulthood, men and women are looking for someone they can see having a family with, and not for the more superfluous things in life (good looks, status or lots of money). At 43, having kids is harder for women, but usually not for men (well, at least making babies: bringing up kids does get a bit harder as you age regardless of the gender).
In any case, getting a job in a place where you'd be happy should "restart" your life: job is also a means to a new social life where you make the break from the old. So it sounds like you are only a decent job away from starting on the right path.
Having some vices also allows you to connect with others, so perhaps pick up a few non-damaging ones :D
Finally, note that you should look for professional help instead of listening to any of the advice I might give, though finding a psychologist who you can connect to is sometimes an ordeal as well.
In any case, getting a job in a place where you'd be happy should "restart" your life: job is also a means to a new social life where you make the break from the old. So it sounds like you are only a decent job away from starting on the right path.
Having some vices also allows you to connect with others, so perhaps pick up a few non-damaging ones :D
Finally, note that you should look for professional help instead of listening to any of the advice I might give, though finding a psychologist who you can connect to is sometimes an ordeal as well.