It gave me an option to add a new card because my old one had expired.

I've found the problem now.

When I first set up my click and buy account when FFXIV first launched I set a monthly spending limit of £8.99 so that FFXIV would be the only thing going out of it. Now, I tried to activate 6 months of play for £34.14 so it blocked transaction.