How can I unpublish the content profile node when users update their user account?
You can use the "Set data"-action to set the profile node's status to 0: status=1 means published, status=0 means unpublished.