i forgot to add semi colon after the each query
DELIMITER //
CREATE PROCEDURE SP_Lock_update(IN locked int(1),IN user_id int)
BEGIN
update user_register , comments,articles
set
user_register.locked=locked,
comments.locked=locked,
articles.locked=locked
where
user_register.user_id=user_id
and
comments.user_id=user_id
and
articles.user_id=user_id;
update comments
set
locked=locked
where article_id in (select article_id from articles where user_id=user_id);
END //
DELIMITER ;