UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZWPq/4wahudwnhdR6Eesx7BopkrIDnJ8Y48AxWcSZDw='
WHERE
key_id = '9d996cf3e868a80b0b0f82c859aa568d26b5fc85f34f070d9db274f9fd61c29c'
AND (
token = 'ZWPq/4wahudwnhdR6Eesx7BopkrIDnJ8Y48AxWcSZDw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)