UPDATE `Users` e,
(SELECT @n := 0) m
SET e.email = concat('my_string+', @n := @n + 1, 'rest')