UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Gqo0v9vXppO8WL3sa0bjn2/PEva/km0jjdzaj12hPwc='
WHERE
key_id = 'b1680f9fe280bcebb9bd38f4dbe6881ea65c1f071d81be3694fb3021e8c578f0'
AND (
token = 'Gqo0v9vXppO8WL3sa0bjn2/PEva/km0jjdzaj12hPwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)