Session SQL
INSERT INTO core_config_data(path, value)
VALUES ('web/cookie/cookie_lifetime', 86400)
ON DUPLICATE KEY UPDATE value = 86400;
or manual:
System -> Configuration
General > Web
Session Cookie management
Cookie Lifetime: 86400
API SQL
INSERT INTO core_config_data(path, value)
VALUES ('api/config/session_timeout', 86400)
ON DUPLICATE KEY UPDATE value = 86400;
or manual:
System -> Configuration
General > Services
Magento Core Api
General Settings
Client Session timeout (sec.): 86400