UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5c8cTZc0lKRwF7DxRyi14qj9fUztl1gmZ+dXB5tg+DI='
WHERE
key_id = '5523608c0a213c8fe7d6c2bfd70e1e12d379c3c72b708229bae09d8876e56a99'
AND (
token = '5c8cTZc0lKRwF7DxRyi14qj9fUztl1gmZ+dXB5tg+DI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)