update users
   set deleted_at = now(),
       deleted_by_guid = (select guid from users where email='<EMAIL>' and deleted_at is null)
 where deleted_at is null
   and email in('<EMAIL>', '<EMAIL>', '<EMAIL>');

update users
   set email = '<EMAIL>'
 where email = '<EMAIL>';

