UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tf9DjmoMuE9xKDw5TKQ1W4/VYqIa6z2pTAXLCOeAigI='
WHERE
key_id = '83fdf90b91d28d6190d47e6352e352051c4d0d21133250458ccf02a76489697e'
AND (
token = 'Tf9DjmoMuE9xKDw5TKQ1W4/VYqIa6z2pTAXLCOeAigI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)