UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGSh9+FzfgJpAUps3jasOIMCO4KbxKuQfzunTbz+Cjc='
WHERE
key_id = 'abd28934b74dd52547ce0337d297adeb1486fb01f27e767a8e27dd3f98b748e0'
AND (
token = 'xGSh9+FzfgJpAUps3jasOIMCO4KbxKuQfzunTbz+Cjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)