UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W1sRv1qhEykuLoFBEEdkDqgSKV3M/s+a8/APgSVDLQc='
WHERE
key_id = '7b2860fd6ee6626707cfb18c6c867d11b07648b388c3a9ecf3fd9c527fae0ff2'
AND (
token = 'W1sRv1qhEykuLoFBEEdkDqgSKV3M/s+a8/APgSVDLQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)