DELIMITER $$

DROP PROCEDURE IF EXISTS `sakila`.`return_film` $$
CREATE PROCEDURE `return_film`(in_customer_id int, in_rental_id int)
BEGIN
    UPDATE rental
       SET return_date=NOW()
     WHERE customer_id=in_customer_id
       AND rental_id=in_rental_id;
END $$

DELIMITER ;