UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/CRpA2Rl2HGDv4+6etk7ve+B/1yODJv3zsyViK0SZTs='
WHERE
key_id = '82f75535d4523dec02a416efb1836e72e05c1435e765ffe12fc0f62d45b4c4cb'
AND (
token = '/CRpA2Rl2HGDv4+6etk7ve+B/1yODJv3zsyViK0SZTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)