UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M7bILPotsk2sfZLPLsuIVDzbQ+5ASI7mVrCsq2M0o8M='
WHERE
key_id = '4c604b52fd31dadb0ea1251cfa4ff4c2136b0d889a040a7d2137f4d985848010'
AND (
token = 'M7bILPotsk2sfZLPLsuIVDzbQ+5ASI7mVrCsq2M0o8M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)