UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm0Z5mEGWNG3TavGBJ9bGy4EkK8ifs27urOL93VmyDMw='
WHERE
key_id = 'fcbcc4246c411cfd68905f4e3516fa0d14e2b1dda6e70add35cd119d8927e374'
AND (
token = 'm0Z5mEGWNG3TavGBJ9bGy4EkK8ifs27urOL93VmyDMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)