You could always make it from scratch, recipes abound. Most large supermarket chains have an Asian food section with the popularity of Thai food there should be some brand of red curry paste on the shelf. If not, there's always Amazon.

I think it comes out better with the vegi based mayo's, especially the avocada based one I last used than traditional mayo's. I've also done it with sour creme instead of mayo, works as well.