When I run this code, it tell that "0 rows" are updated

And if you query the value that was changed, is it correct?

That is, is only the count wrong, or does nothing happen?

You should also be aware that errors can not only happen during prepare(), but also during executed() - setting the RaiseError => 1 option means you won't miss any error silently.