I have been in retail for over 40 years and I need to get out NOW. But wtf do i do. I really hate my job?

My boss is a ***** and has no respect for any one but herself. She doesn't appreciate the work we do for her and never has a good word to say about anyone. You can't reason with her because she is always right (she's god). She thinks the store will close if she isn't there(that's BS) I can't afford to quit until I find another job but my age is against me (56) and I don't have a college degree.What I do have is 40 years of customer service and a background in food(meat and grocery). I am willing to transfer out of state but my wife and son aren't. My wifes mother is ageing and my son will be in college this fall and he won't leave his GF of 3 years. So WTF do I do. I am in a catch 22 and I hate it. I have prayed about this and talked to many people and no one seems to have any answers so I am ing my head against a brick wall and it really hurts. I am really getting tired and don't know how much more I can take.