try rewriting it to something like:
update users set price = p.price from prices p where p.type ='normal_price' and p.currency = users.currency;