DROP PROCEDURE IF EXISTS `procedure_foo`;
DELIMITER $$
CREATE PROCEDURE `procedure_foo`()
BEGIN
    DECLARE id int default 0;
    INSERT INTO cms_form_completed_advocacy_letter (created_at) VALUES (NOW());
    SET id = last_insert_id();
    IF id <> 0 THEN

        INSERT INTO cms_form_completed_advocacy_letter_recipients (form_completed_advocacy_letter_id, hash_id, user_contact_id) VALUES (id, id, 4);

    END IF;
END
$$
DELIMITER ;

CALL procedure_foo();
DROP PROCEDURE IF EXISTS `procedure_foo`;