UPDATE table_members t INNER JOIN
       table_oldnewemail tno
       ON t.email = tno.old_email
    SET t.email = tno.new_email;