UPDATE ubbt_USERS SET USER_LOGIN_NAME='NewUsername'
WHERE USER_LOGIN_NAME='OldUsername'
the KEY is that the NewUsername be unique..
this is the name that the user logs in as..
the display name is a different beast and can already be changed in the admin cpanel or (if enabled) the user can change it themselves in their profile