UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sncKCUf3WtaRPlfEYcGD8hfhlVR8HEFZvvupRtkndQI='
WHERE
key_id = '6e18ab2e1e8ef3eaa57f94271ad4ac26a2390699d9bd764d18d84b03eb8daefe'
AND (
token = 'sncKCUf3WtaRPlfEYcGD8hfhlVR8HEFZvvupRtkndQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)