UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j6HcO0sudxonw7VfLhbeZAgPAFWDNAU/uUoLE7YAMds='
WHERE
key_id = 'e9dd44b1d3ca3b464b5bc4cc2dda0ca621404cb4549d4b27e3f7007197f93faa'
AND (
token = 'j6HcO0sudxonw7VfLhbeZAgPAFWDNAU/uUoLE7YAMds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)