不小心删除密码后,将密码哈希值分配给wordpress用户

I've accidentally updated some user passwords to have an empty string ''.

From a database backup I have the hashed values of their passwords. How can I assign these hashed values back to their account? The wp-cli for update seems to send a email for an update and I don't want that.

I've tried updating it via SQL but it does not seem to work.

update wp_users set user_pass = '$2a$14$pdLULKQeENo0j7ad6U4QuOHqgo6DmaQiB4wAhYZMEGguYGqQNIaIa'
where user_email = 'test@email.com' and user_pass = '';