Most of my self inflating pads and air mattresses were bought at REI scratch and dent sales with leaks. At home when I find the leak point, a tiny dab of Seam Grip works great. If it is a larger hole, I use the Seam Grip to glue on a small bit of nylon as a patch.
And if I get a leak on a trip, I discovered that self adhesive inner tube patches work great, photo of one of my air mattresses with the new patch. Later at home I peeled off the patch and used Seam Grip to do a proper repair. I now make sure I bring a few self adhesive patches on all my trips including backpacking, canoe, and kayak trips.
I made the mistake once of using something other than Seam Grip, the permanent patch became a temporary one on a trip.
So, when you take your self inflating pad on your colder trips, I suggest you have some patches along.