UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's5sKEmZG4yGJQmy2PqLDMkeTC579XvfXqQ2L6xC1PZA='
WHERE
key_id = '8c71ec8b049acae3739ef2a9b22be74fbec0f1315c0b1e724d7a8fa4795781ab'
AND (
token = 's5sKEmZG4yGJQmy2PqLDMkeTC579XvfXqQ2L6xC1PZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)