When I enter my Sims 3 product code it says ''This code has already been used''.

My guess is as good as yours, but I think it's been someone who was putting in random codes and hoping to get lucky, and they ended up getting yours for free. The only thing you can do is contact an administrator on Origin. If that doesn't work, you'll pretty much have to buy a new, unused copy to be safe.