select

	pr.*,
  round((pr.price * 1.2), 2 ) as 'round_price_2',
  round( (pr.price * 1.2) / 0.05, 0) * 0.05 as 'new_price_2_05'

from
	xcart_pricing as pr
where
	pr.membershipid = 0

use round( (pr.price * 1.2) / 0.05, 0) * 0.05 to round to the nearest 5p

update
	xcart_pricing as pr
set
	pr.price = round( (pr.price * 1.2) / 0.05, 0) * 0.05
where
	pr.membershipid = 0
  and pr.price > 0