UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjEHAC0HXClUt0fUClnUiWJQaiXAit2kPwK8MxcGKk4='
WHERE
key_id = '9f24ca75945a4a3fb6a3dfdb2e149459184ac1f80c641712fe586300dd38b28f'
AND (
token = 'hjEHAC0HXClUt0fUClnUiWJQaiXAit2kPwK8MxcGKk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)