UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '65Wy2+Xt4T7gu+JCPRfmrlhyfeAXzOBOI1ff1Tmipjg='
WHERE
key_id = '3622e8366c32129f5b95eb282f2b2b17b066b724c8c628ddb7875a8f6b76b3e2'
AND (
token = '65Wy2+Xt4T7gu+JCPRfmrlhyfeAXzOBOI1ff1Tmipjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)