UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9I+0hAhH0cTJcIrvvJjM9DZxE27OyLMspBtiJghlho0='
WHERE
key_id = 'be07ca198a60938919b546237ef3acea6da9c177ff20247b6b021d213aad6afc'
AND (
token = '9I+0hAhH0cTJcIrvvJjM9DZxE27OyLMspBtiJghlho0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)