The full phrase is "happy as a clam at high tide." Clams can only be dug up at low tides, so at high tide a clam is safer and secure, so therefore, happy.
Dude: "You seem really chuffed with life and comfortable in your own skin."
Other Dude: "Hells yeah! Man, I'm as happy as a clam!"