USP_APISUBSCRIPTIONKEY_UPSERT

        CREATE procedure dbo.USP_APISUBSCRIPTIONKEY_UPSERT
        (
          @CHANGEAGENTID uniqueidentifier = null,
          @APISUBSCRIPTIONKEY nvarchar(4000)
        )
        as
        begin

          declare @ID uniqueidentifier = newid()

          if @CHANGEAGENTID is null  
            exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

          declare @CURRENTDATE datetime = getdate()

          exec dbo.USP_GET_KEY_ACCESS
          begin try
            if exists(select ID from APISUBSCRIPTIONKEY)
            begin
              update dbo.APISUBSCRIPTIONKEY set
                APISUBSCRIPTIONKEY = EncryptByKey(Key_GUID('sym_BBInfinity'), @APISUBSCRIPTIONKEY),
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
              end
            else
            begin
              insert into dbo.APISUBSCRIPTIONKEY
                (ID, APISUBSCRIPTIONKEY, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                values
                (@ID, EncryptByKey(Key_GUID('sym_BBInfinity'), @APISUBSCRIPTIONKEY), @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE)
            end

            close symmetric key sym_BBInfinity
          end try
          begin catch
            exec dbo.USP_RAISE_ERROR
            close symmetric key sym_BBInfinity
            return 1
          end catch 

        end