UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DWDgh8lH+/Nrge2lO1hogxi7D4sW6cEEsJmmHTZPtmo='
WHERE
key_id = '8355a8df24cddc2b462fd83d8864ca4f10fa83f80c04f6893a8584d3674f7aaf'
AND (
token = 'DWDgh8lH+/Nrge2lO1hogxi7D4sW6cEEsJmmHTZPtmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)