UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1NiOm2lNq1/PVgLWabMF+zQ0326facGoZyUaO1pv8+U='
WHERE
key_id = '828824d50e38a8698d4fd9510805ea047b68dfcd125fb5d83137cc49338c996c'
AND (
token = '1NiOm2lNq1/PVgLWabMF+zQ0326facGoZyUaO1pv8+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)