UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VI6lroMREkDidYozbwIG+RdN0mD1WjCfOgbP5PUgkuY='
WHERE
key_id = '163e1c05c984e3f01cc468685d974b2efa1eec37127722c013d4193a6759363f'
AND (
token = 'VI6lroMREkDidYozbwIG+RdN0mD1WjCfOgbP5PUgkuY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)