Return and Check exists in MySql Stored Procedure

DELIMITER $$
drop procedure if exists

`Promoter_Save`$$
create PROCEDURE `Promoter_Save`(IN `pUserId` BIGINT, IN `pPromoterCode` VARCHAR(50), IN `pPromoterTypeId` BIGINT , IN `pActive` BIT)

BEGIN

IF not exists (select * from promoter where UserId=pUserId) THEN

insert into promoter
   (
    UserId,
 PromoterCode,
 PromoterTypeId,
 Active        
   )
   values
   (
    pUserId,
 pPromoterCode,
 pPromoterTypeId,
 pActive
);
ELSE

update promoter
 
   set
  PromoterCode=pPromoterCode,
  PromoterTypeId=pPromoterTypeId,
 Active=pActive    
   where UserId=pUserId;
 
END IF;
select last_insert_id();
END$$
DELIMITER ;

Stored Procedure in MySql

drop procedure if exists paymenttype_save$$
create PROCEDURE paymenttype_save(
IN pId INT,
IN pName varchar(50),
IN pUpdatedId INT,
IN pUpdatedDate Date
)
BEGIN

IF pId<1 THEN

insert into paymenttype
    (
     Name,
     UpdatedId,
     UpdatedDate  
    )
    values
    (
     pName,
     pUpdatedId,
     pUpdatedDate
    );
ELSE

update paymenttype
   
    set Name=pName,
      UpdateId=pUpdateId,
      UpdateDate=pUpdateDate
      where Id=pId;
   
END IF;

END$$
DELIMITER ;