UPDATE `abc`.`products` SET `products_status` = '1' WHERE `products_status`=0  ORDER BY RAND() LIMIT 50

复杂的版本：

UPDATE `abc`.`products` SET `products_status` = '1' WHERE `products`.`products_id` in (select t.products_id from (select * from products where `products_status`=0  ORDER BY RAND() LIMIT 50)as t)