UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YUUCdKL+HeBvNW+TYuxCi0qLJ6vhsZGYknxGRF9F47I='
WHERE
key_id = '874e4cc47c91a58798923ec66cc44a890ad4efc8f462455470a13ad7b371997b'
AND (
token = 'YUUCdKL+HeBvNW+TYuxCi0qLJ6vhsZGYknxGRF9F47I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)