I had huge problems over the last couple of days. Looking at the Steam forums we're not the only ones either. I finally fixed it by deleting everything from my Steam folder bar the Steam .exe and the steamapps folder, then running the .exe. After a few tries I managed to successfully update Steam and log in.