UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49MWYqKsQOtZYQfnKokEZRuIC+1KCnyf5DwEMWANGRA='
WHERE
key_id = '6c6d141aa4dbd8901c65434de3654832ca8356b9cd28a4e5b1e4011ffb309410'
AND (
token = '49MWYqKsQOtZYQfnKokEZRuIC+1KCnyf5DwEMWANGRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)