XF 1.5 Mass updating user state through query

[Alpha1]

I have close to 10k accounts that have a wrong user state: email_confirm instead of email_bounce. This is likely caused by vbulletin import somehow.
These accounts all have posts, so the following query will select the accounts:
SELECT * FROM xf_user WHERE message_count != 0 AND user_state = 'email_confirm';

How do I update the user state to email_bounce ?

Would this work or is this erroneous:
UPDATE xf_user SET user_state = 'email_bounce' WHERE xf_user.`message_count` != 0 AND user_state = 'email_confirm';

 

[TickTackk]

UPDATE xf_user
SET user_state = 'email_bounce'
WHERE message_count <> 0
  AND user_state = 'email_confirm'

 

[Alpha1]

Thanks!