UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgD0KFt+mbtsYiKozaf4/UcogCfdKWZKv5bnN/YuoY4='
WHERE
key_id = '663710540f7cd78694060c5181f1d88e741ce0c1ba014ce8086bae44244b44d7'
AND (
token = 'xgD0KFt+mbtsYiKozaf4/UcogCfdKWZKv5bnN/YuoY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)