UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SOqy4ZcUXy9SUXStvHkGaOVOaHeKNuu01wonKNWQk9g='
WHERE
key_id = '3379665cf622b005977b6d5ff296f1b73822a44cf6089a1a8f2c0e13715f2e40'
AND (
token = 'SOqy4ZcUXy9SUXStvHkGaOVOaHeKNuu01wonKNWQk9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)