UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NK/Ag+lt5ez4To98Mz/g2dul/hoMUjARsrEeXxPVIdw='
WHERE
key_id = 'bf27a594ffe2868f073525fb70b6363898c9b4b10b3d95e42b453a7bb6a9cb82'
AND (
token = 'NK/Ag+lt5ez4To98Mz/g2dul/hoMUjARsrEeXxPVIdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)