The same as shakin' in my boots, which means scared. The phrase is used sarcastically often.

The specific term comes from Austin Powers in which Dr. Evil says "I'm shaking in my little space boots", although some falsely attribute it to Toy Story. Also, the "little" is commonly skipped from the phrase.

When you eat dirt for the first time and leave your family to build a shack in the woods