UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KbdpyhOT4ncBSQ6aguaBP6KIwDwTYQvYqxBzNSHCH3E='
WHERE
key_id = '203c6fee86130304d9eb67b6ed6613bb9a69c741bea44a4d3380a33622058fb6'
AND (
token = 'KbdpyhOT4ncBSQ6aguaBP6KIwDwTYQvYqxBzNSHCH3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)